﻿<?xml version="1.0" encoding="utf-8"?>
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.1" Build="10.0.1600.22">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementText="SELECT * FROM [dbo].[CustomerData] WHERE [custid]=@1" StatementId="1" StatementCompId="1" StatementType="SELECT" StatementSubTreeCost="0.0032831" StatementEstRows="1" StatementOptmLevel="TRIVIAL" QueryHash="0x989F8A33CCBB3627" QueryPlanHash="0x8BE5853954CF9BB6">
          <StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false" />
          <QueryPlan DegreeOfParallelism="1" CachedPlanSize="16" CompileTime="1" CompileCPU="1" CompileMemory="72">
            <RelOp NodeId="0" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="16069" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="1" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
              <OutputList>
                <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[CustomerData]" Column="custid" />
                <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[CustomerData]" Column="txt_data" />
                <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[CustomerData]" Column="ntxt_data" />
                <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[CustomerData]" Column="binary_data" />
                <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[CustomerData]" Column="xml_data" />
              </OutputList>
              <RunTimeInformation>
                <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
              </RunTimeInformation>
              <IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" NoExpandHint="0">
                <DefinedValues>
                  <DefinedValue>
                    <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[CustomerData]" Column="custid" />
                  </DefinedValue>
                  <DefinedValue>
                    <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[CustomerData]" Column="txt_data" />
                  </DefinedValue>
                  <DefinedValue>
                    <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[CustomerData]" Column="ntxt_data" />
                  </DefinedValue>
                  <DefinedValue>
                    <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[CustomerData]" Column="binary_data" />
                  </DefinedValue>
                  <DefinedValue>
                    <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[CustomerData]" Column="xml_data" />
                  </DefinedValue>
                </DefinedValues>
                <Object Database="[tempdb]" Schema="[dbo]" Table="[CustomerData]" Index="[PK__Customer__973AFEFE45F365D3]" IndexKind="Clustered" />
                <SeekPredicates>
                  <SeekPredicateNew>
                    <SeekKeys>
                      <Prefix ScanType="EQ">
                        <RangeColumns>
                          <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[CustomerData]" Column="custid" />
                        </RangeColumns>
                        <RangeExpressions>
                          <ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[@1],0)">
                            <Convert DataType="int" Style="0" Implicit="1">
                              <ScalarOperator>
                                <Identifier>
                                  <ColumnReference Column="@1" />
                                </Identifier>
                              </ScalarOperator>
                            </Convert>
                          </ScalarOperator>
                        </RangeExpressions>
                      </Prefix>
                    </SeekKeys>
                  </SeekPredicateNew>
                </SeekPredicates>
              </IndexScan>
            </RelOp>
            <ParameterList>
              <ColumnReference Column="@1" ParameterCompiledValue="(101)" ParameterRuntimeValue="(101)" />
            </ParameterList>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>